
-- ${comments!} 生成主键sql
INSERT INTO comm_bussiness_primary_key
(bussiness_table_name, primary_key_id, no_prefix, no_date_id, no_serial_number_length,
current_date_str, max_serial_number, control_state, is_unify, primary_key_name,
foreign_key_name, parent_table_name, bussiness_no, delete_order, delete_field_name,
delete_parent_field_name, is_system, is_default, primary_key_no, check_status,
is_use, remark, create_user_id, create_date, last_modify_user_id,
last_modify_date, version_id)
VALUES('${tableName}', 1, 'NO', 2, 5,
'20140122', 1, 1, 1, '${pk.columnName}',
'NULL', '${tableName}', '', 1, '${pk.columnName}',
'${pk.columnName}', 1, 1, NULL, NULL,
1, '', 13, now(), 13,
now(), 1);

-- ${comments!} 生成业务
-- bussiness_no,bussiness_name, belonging_id,navigation_path, parent_bussiness_no需要自己填写
INSERT INTO comm_bussiness
(bussiness_no, bussiness_name, bussiness_type_id, bussiness_division_id, belonging_id,
order_num, is_audit, is_push, navigation_path, parent_bussiness_no,
table_name, primary_key_name, control_state_id, auth_manage, machine_type_id,
system_id, remark, create_user_id, create_date, last_modify_user_id,
last_modify_date, version_id)
VALUES('?1', '?2', 1, 0, ?3,
0, 0, 1, '?4', '?5',
'${tableName}', '${pk.columnName}', 2, NULL, 0,
16, NULL, 1, now(), 1,
now(), 1);

INSERT INTO comm_bussiness_operation
(bussiness_operation_no, bussiness_no, operation_no, operation_name, remark, version_id)
VALUES('?1.ADD', '?1', 'ADD', '新建', '${comments!} ', 1);
INSERT INTO comm_bussiness_operation
(bussiness_operation_no, bussiness_no, operation_no, operation_name, remark, version_id)
VALUES('?1.DELETE', '?1', 'DELETE', '删除', '${comments!} ', 1);
INSERT INTO comm_bussiness_operation
(bussiness_operation_no, bussiness_no, operation_no, operation_name, remark, version_id)
VALUES('?1.EXPORT', '?1', 'EXPORT', '导出', '${comments!} ', 1);
INSERT INTO comm_bussiness_operation
(bussiness_operation_no, bussiness_no, operation_no, operation_name, remark, version_id)
VALUES('?1.MODIFY', '?1', 'MODIFY', '修改', '${comments!} ', 1);
INSERT INTO comm_bussiness_operation
(bussiness_operation_no, bussiness_no, operation_no, operation_name, remark, version_id)
VALUES('?1.QUERY', '?1', 'QUERY', '查询', '${comments!} ', 1);